Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(16) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(6) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Kategoria dostepnosci leku |
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(128) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Dawka |
Name |
|
Code |
|
Data Type |
VARCHAR2(42) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Warunkuje czy firma jest producentem |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
CLOB |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
CLOB |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(12) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Okres waznosci |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Wartosc zdefiniowanej dawki dziennej (defined daily dose) |
Name |
|
Code |
|
Data Type |
VARCHAR2(4) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(4) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(128) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(128) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(19,4) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(10) |
Mandatory |
Yes |
Comment |
Lek refundowany |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
Kod kreskowy leku, Europejski Kod Towarowy |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Flaga informujaca o tym czy lek jest szczepionka. |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Flaga koniec dopuszczenia |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Flaga dopuszczony do obrotu |
Name |
|
Code |
|
Data Type |
VARCHAR2(6) |
Mandatory |
No |
Comment |
Synonim zbiorczy |
Name |
|
Code |
|
Data Type |
VARCHAR2(6) |
Mandatory |
No |
Comment |
Zbiór odpowiedników zlozonych |
Name |
|
Code |
|
Data Type |
VARCHAR2(42) |
Mandatory |
No |
Comment |
Jednostka leku |
Name |
|
Code |
|
Data Type |
VARCHAR2(42) |
Mandatory |
No |
Comment |
Jednostka opakowania |
Name |
|
Code |
|
Data Type |
NUMBER(18,8) |
Mandatory |
No |
Comment |
Ilosc sztuk w opakowaniu |
Name |
|
Code |
|
Data Type |
NUMBER(18,8) |
Mandatory |
No |
Comment |
Ilosc leku w opakowaniu |
Name |
|
Code |
|
Data Type |
NUMBER(18,8) |
Mandatory |
No |
Comment |
Ilosc dawki |
Name |
|
Code |
|
Data Type |
VARCHAR2(16) |
Mandatory |
No |
Comment |
Jednostka dawki |
Name |
|
Code |
|
Data Type |
NUMBER(18,8) |
Mandatory |
No |
Comment |
Objetosc dawki |
Name |
|
Code |
|
Data Type |
VARCHAR2(16) |
Mandatory |
No |
Comment |
Jednostka objetosci dawki |
Name |
|
Code |
|
Data Type |
VARCHAR2(11) |
Mandatory |
No |
Comment |
Grupy leków psychotropowych, odurzajacych, prekursorów |
Name |
|
Code |
|
Data Type |
VARCHAR2(2) |
Mandatory |
No |
Comment |
Stawka VAT |
Name |
|
Code |
|
Data Type |
VARCHAR2(21) |
Mandatory |
No |
Comment |
Numer swiadectwa rejestracji |
Name |
|
Code |
|
Data Type |
VARCHAR2(21) |
Mandatory |
No |
Comment |
Data wydania swiadectwa |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data aktualizacji danych o leku |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Rodzaj produktu (opatrunek, endoproteza, Srodek dezynfekcyjny, inne) |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Informacja czy produkt jest lekiem |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Informacja czy produkt jest produktem medycznym |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Produkt jest antybiotykiem |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Produkt biobójczy |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Produkt dostepny jedynie w lecznictwie zamknietym |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Lek refundowany dostepny w ramach programu lekowego |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Lek refundowany dostepny w ramach chemioterapii |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Opakowanie szpitalne |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Produkt nieobecny juz na rynku wedlug informacji podmiotu |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Produkt biotechnologiczny |
Name |
|
Code |
|
Data Type |
VARCHAR2(16) |
Mandatory |
No |
Comment |
Symbol Wspólnego Slownika Zamówien |
Name |
|
Code |
|
Data Type |
VARCHAR2(16) |
Mandatory |
No |
Comment |
Symbol Nomenklatury Scalonej (CN)/Kod HS |
Name |
|
Code |
|
Data Type |
VARCHAR2(14) |
Mandatory |
No |
Comment |
Symbol PKWiU |
Name |
|
Code |
|
Data Type |
VARCHAR2(21) |
Mandatory |
No |
Comment |
Numer swiadectwa dopuszczenia do obrotu |
Name |
|
Code |
|
Data Type |
NUMBER(19,4) |
Mandatory |
No |
Comment |
Cena urzedowa hurtowa |
Name |
|
Code |
|
Data Type |
NUMBER(19,4) |
Mandatory |
No |
Comment |
Cena urzedowa zbytu |
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
Kod MD5 tworzony na podstawie danych z wszystkich kolumn tabeli |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data ostatniej modyfikacji |
Name |
|
Code |
|
Data Type |
NUMBER(19,4) |
Mandatory |
No |
Comment |
Wysokosc limitu finansowania dla leków refundowanych |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
kolumna bedzie przechowywac informacje o sile dzialania leku (A - bazdzo silne,B - silne, N - psychotropowe, ND - nie dotyczy |
Name |
|
Code |
|
Data Type |
VARCHAR2(5) |
Mandatory |
No |
Comment |
Kod odnoszacy sie do substancji czynnej, srodka spozywczego, wyrobu medycznego, które moga byc ordynowane przez pielegniarki/polozne. |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
PLTL-12202 [COI] Wystawianie recept na substancje odurzajace |
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
Kod GTIN produktu Globalny Numer Jednostki Handlowej |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
obecnosci produktu na rynku farmaceutycznym w Polsce w okresie ostatnich pelnych 3 miesiecy |
Name |
Code |
Primary |
X |
Name |
|
Code |
|
Primary |
Yes |
Comment |
|
|
|
|